**************************************************************************
**************************************************************************
******************** POLITICAL LAND CORRUPTION: **************************
**** EVIDENCE FROM MALTA - THE EUROPEAN UNION'S SMALLEST MEMBER STATE ****
**************************************************************************
**************************************************************************
********* PAUL CARUANA-GALIZIA AND MATTHEW CARUANA-GALIZIA ****************
**************************************************************************
**************************************************************************


cd "/Users/Paul/Dropbox/MEPA/"
import excel "/Users/Paul/Dropbox/MEPA/MEPA_Data.xls", sheet("Rest") firstrow clear

**time setting**
label variable tt "Time Trend"
format date %td
tsset tt

**labels
label variable applications "Applications"
label variable ratio "Ratio"
label variable ratio_1 "Ratio t-1"
label var refgrantratio "Officer refusal, Board grant"
label var grantrefratio "Officer grant, Board refusal"
label variable pop_den "Population Density"
label variable pd_1 "Population Density t-1"
label variable unemp "Unemployment Rate"
label variable u_1 "Unemployment Rate t-1"
label variable houseprice "House Price Index"
label variable hp_1 "House Price Index t-1"
label variable sharpe "Sharpe ratio"
label variable app_1 "Applications t-1"
label variable sharpe_1 "Sharpe t-1"
label var lhp "ln House Price"
label var lpd "ln Pop. Den."
label var lrat "ln Ratio"
label var lapp "ln Applications"
label var luemp "ln Unemp."
label var sm3_hp "q.m-a. House Price"
label var sm3_pd "q.m-a. Pop. Den."
label var sm3_rat "q.m-a. Ratio"
label var sm3_app "q.m-a. Applications"
g sm3_app_1= sm3_app[_n-1]
label var sm3_app "q.m-a. Applications t-1"
label var sm3_unemp "q.m-a. Unemp."
label var sm3_refgrantratio "q.m-a. Reversal Ratio"
label var refgrantratio_1 "Reversal ratio t-1"
label var refgrantratio "Reversal ratio"
gen lapp_1=lapp[_n-1]
label var lapp_1 "ln Applications t-1"


label variable Advertisement "Advert."
label variable Amendeddevelopmentpermission "Ammended."
label variable Approvalofdetailsreservedby "Reserve Condition."
label variable Fulldevelopmentpermission "Full Permission"
label variable Householderdevelopmentpermissi "Householder."
label variable Internalalterations "Internatl Alt."
label variable Outlinedevelopmentpermission "Outline."
label variable Pre1993Application "Pre-1993"
label variable QuarryingMineralsextraction "Quarrying, Mining."
label variable Renewalofdevelopmentpermissio "Renewal"
label variable SchdpropLBConservatnarea "Scheduled."
label variable Telecommunicationsantennae "Telecomms."
		
gen notype=Telecommunicationsantennae+QuarryingMineralsextraction+Internalalterations
label variable notype "Unaffected types"
gen protype=Approvalofdetailsreservedby+Amendeddevelopmentpermission+Advertisement+SchdpropLBConservatnarea+Renewalofdevelopmentpermissio+Pre1993Application+Outlinedevelopmentpermission+Householderdevelopmentpermissi+Fulldevelopmentpermission
label variable protype "Affected types"

* TABLE 1
table year, contents(sum applications sum grants sum refusals mean ratio )
***Annual mean and Annual std. dev. rows are calculated from the values
***in the table above. Total sum row calculated with below command.*****
tabstat applications grants refusals, statistics( sum ) columns(variables)

* TABLE 2
tabstat Advertisement Amendeddevelopmentpermission  ///
Approvalofdetailsreservedby Fulldevelopmentpermission ///
Householderdevelopmentpermissi Internalalterations ///
Outlinedevelopmentpermission Pre1993Application ///
QuarryingMineralsextraction Renewalofdevelopmentpermissio ///
SchdpropLBConservatnarea ///
Telecommunicationsantennae, statistics( sum ) columns(statistics)
***Total, when given row is the sum of the above table values. The % of Total
***column values are the row-wise percentages of the Total, when given row.***


* TABLE 3
**Myopic**
poisson applications app_1 hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_Tab3.doc, replace ctitle(Myopic) ///
title(Table 3: ODZ applications and house prices - Poisson estimates) ///
keep(app_1 hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y) label

**Adaptive**
poisson applications app_1 sharpe  pop_den ratio unemp tt, ro
outreg2 using MEPA_Tab3.doc, append ctitle(Adaptive) ///
title(Table 3: ODZ applications and house prices - Poisson estimates) ///
keep(app_1 sharpe  pop_den ratio unemp) addtext(Time Trend, Y) label

**Rational**
poisson applications app_1  houseprice pop_den ratio unemp tt, ro
outreg2 using MEPA_Tab3.doc, append ctitle(Rational) ///
title(Table 3: ODZ applications and house prices - Poisson estimates) ///
keep(app_1 houseprice pop_den ratio unemp) addtext(Time Trend, Y) label


* TABLE 4
**Myopic**
reg refgrantratio refgrantratio_1  hp_1 pd_1  u_1 tt, ro
outreg2 using MEPA_Tab4.doc, replace ctitle(Myopic) ///
title(Table 4: Reversal ratio and house prices- OLS estimates) ///
keep(refgrantratio_1 app_1 hp_1 pd_1  u_1) addtext(Time Trend, Y) label

**Adaptive**
reg refgrantratio refgrantratio_1  sharpe  pop_den  unemp tt, ro
outreg2 using MEPA_Tab4.doc, append ctitle(Adaptive) ///
title(Table 4: Reversal ratio and house prices- OLS estimates) ///
keep(refgrantratio_1 sharpe  pop_den  unemp) addtext(Time Trend, Y) label

**Rational**
reg refgrantratio refgrantratio_1  houseprice pop_den  unemp tt, ro
outreg2 using MEPA_Tab4.doc, append ctitle(Rational) ///
title(Table 4: Reversal ratio and house prices- OLS estimates) ///
keep(refgrantratio_1   houseprice pop_den  unemp) addtext(Time Trend, Y) label

* TABLE A1
poisson applications hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, replace ctitle(Applications) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
 keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Advertisement hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Advert.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Amendeddevelopmentpermission hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Ammended.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Approvalofdetailsreservedby hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Reserve Condition.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Fulldevelopmentpermission hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Full Permission) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Householderdevelopmentpermissi hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Householder.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Internalalterations hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Internatl Alt.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Outlinedevelopmentpermission hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Outline.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Pre1993Application hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Pre-1993) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
 keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label
		
poisson QuarryingMineralsextraction hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Quarrying, Mining.) ///
 title(Table A1: ODZ application types and house prices - Poisson estimations) ///
  keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Renewalofdevelopmentpermissio hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Renewal) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
 keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson SchdpropLBConservatnarea hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Scheduled.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
 keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson Telecommunicationsantennae hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Telecomms.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

poisson protype hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Affected Types.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label
		
poisson notype hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA1.doc, append ctitle(Unaffected Types.) ///
title(Table A1: ODZ application types and house prices - Poisson estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

* TABLE A2
reg housepr pop unem tt , ro
outreg2 using MEPA_TabA2.doc, ///
replace ctitle(House Price Index) ///
 title(Table A2: Fundamental and speculative drivers of house prices) ///
 keep(pop_den unemp) addtext(Time Trend, Y, Estimation, OLS)  label

predict hpresi, residuals
label variable hpresi "Fundamental Model Residuals"

gen hpresi_1= hpresi[_n-1]
label variable hpresi_1 "Fundamental Model Residuals t-1"

poisson applications hpresi_1 tt , ro

outreg2 using MEPA_TabA2.doc, ///
append ctitle(Applications) ///
title(Table A2: Fundamental and speculative drivers of house prices) ///
keep(hpresi_1) addtext(Time Trend, Y, Estimation, Poisson) label

poisson applications hpresi tt, ro
outreg2 using MEPA_TabA2.doc, ///
append ctitle(Applications) ///
title(Table A2: Fundamental and speculative drivers of house prices) ///
keep(pop_den unem hpresi) addtext(Time Trend, Y, Estimation, Poisson) label

* TABLE A6
reg housepr pop unem tt , ro
outreg2 using MEPA_TabA6.doc, ///
replace ctitle(House Price Index) title(Table A6: Fundamental and speculative ///
drivers of house prices - Reversal Ratio) keep(pop_den unemp) ///
addtext(Time Trend, Y, Estimation, OLS)  label

reg refgrantratio hpresi_1 tt , ro
outreg2 using MEPA_TabA6.doc, append ctitle(Reversal ratio) ///
title(Table A6: Fundamental and speculative drivers of house prices) ///
keep(hpresi_1) addtext(Time Trend, Y, Estimation, OLS) label

reg refgrantratio hpresi tt, ro
outreg2 using MEPA_TabA6.doc,append ctitle(Reversal ratio) ///
 title(Table A6: Fundamental and speculative drivers of house prices) ///
 keep(pop_den unem hpresi) addtext(Time Trend, Y, Estimation, OLS) label

* FIGURE 1
tsset tt
tssmooth ma ratio_12=ratio,  window(12)
label var ratio_12 "Grant ratio, 12-month moving-average"
tsset date

tsline ratio ratio_12, ///
 xline(`=d(26oct1996)' `=d(05sep1998)' `=d(12apr2003)' `=d(08mar2008)' ///
 `=d(09mar2013)', lcolor(gs13) lwidth(thick)) ///
 graphregion(color(white)) bgcolor(white) lcolor(black gray) ///
 ytitle(Ratio) xtitle("")
graph save Graph "/Users/Paul/Dropbox/MEPA/Figure 1.gph", replace

* FIGURE 2
tsset date
tsline refgrantratio grantrefratio, ///
 xline(`=d(26oct1996)' `=d(05sep1998)' `=d(12apr2003)' `=d(08mar2008)' ///
 `=d(09mar2013)', lcolor(gs13) lwidth(thick)) ///
 graphregion(color(white)) bgcolor(white) lcolor(black gray) ///
 ytitle(% of all decisions) xtitle("")
graph save Graph "/Users/Paul/Dropbox/MEPA/Figure 2.gph", replace

* TABLE A3 & TABLE A7
reg lapp lapp_1 lhp lpd lrat lue tt, ro 
outreg2 using MEPA_TabA3.doc, replace ctitle(Logs) ///
title(Table A3: ODZ applications and house prices ) keep(lapp_1 lhp lpd lrat lue) ///
addtext(Time Trend, Y, Estimation, OLS) label

reg sm3_app sm3_app_1  sm3_hp sm3_pd sm3_rat sm3_unemp tt, ro
outreg2 using MEPA_TabA3.doc,append ctitle(Quarterly-smoothing) ///
title(Table A3: ODZ applications and house prices ) ///
keep(sm3_app_1  sm3_hp sm3_pd sm3_rat sm3_unemp) ///
addtext(Time Trend, Y, Estimation, OLS) label

tsset tt
poisson applications l.applications l2.applications l3.applications ///
houseprice pop_den ratio unemp tt, ro
outreg2 using MEPA_TabA3.doc, append ctitle(Auto-Regressive) ///
title(Table A3: ODZ applications and house prices ) ///
keep(l.applications l2.applications l3.applications houseprice pop_den ratio unemp) ///
addtext(Auto-Reg. Lags, 3, Time Trend, Y, Estimation, Poisson) label

g lrever=ln(refgrantratio)
label var lrever "ln Reversal ratio"
g lrever_1=lrever[_n-1]
label var sm3_refgrantratio "q.m-a. Reversal ratio"

g sm3_refgrantratio_1=sm3_refgrantratio[_n-1]
label var sm3_refgrantratio_1 "q.m-a. Reversal ratio t-1"
	
g refgrantratio_2=refgrantratio[_n-2]
g refgrantratio_3=refgrantratio[_n-3]

	
reg lrever lrever_1 lhp lpd  lue tt, ro 
outreg2 using MEPA_TabA7.doc, replace ctitle(Logs-rev.) ///
title(Table A7: ODZ approvals, reversal and house prices ) ///
keep(lrever_1 lhp lpd  lue) addtext(Time Trend, Y, Estimation, OLS) label

reg sm3_refgrantratio sm3_refgrantratio_1  sm3_hp sm3_pd  sm3_unemp tt, ro
outreg2 using MEPA_TabA7.doc, append ctitle(Quarterly-smoothing-rev.) ///
title(Table A7: ODZ approvals, reversal and house prices ) ///
keep(sm3_refgrantratio_1  sm3_hp sm3_pd  sm3_unemp ) ///
addtext(Time Trend, Y, Estimation, OLS) label

reg refgrantratio refgrantratio_1 refgrantratio_2 refgrantratio_3 houseprice ///
pop_den ratio unemp tt, ro
outreg2 using MEPA_TabA7.doc, append ctitle(Auto-Regressive-rev.) ///
title(Table A7: ODZ approvals, reversal and house prices ) ///
keep(l.refgrantratio l2.refgrantratio l3.refgrantratio houseprice pop_den ratio unemp ) ///
addtext(Auto-Reg. Lags, 3, Time Trend, Y, Estimation, OLS) label
			
* quarterly estimations			
import excel "/Users/Paul/Dropbox/MEPA/MEPA_Data.xls", sheet("A3-7 Quarterly") firstrow clear
		g tt=_n
		tsset tt
		label variable hp "House Price"
		label variable ratio "Ratio"
		label variable unemp "Unemp."
		label var refgrant "Reversal Ratio"
		g refgrant_1=refgrant[_n-1]
		label var refgrant_1 "Reversal Ratio t-1"
		g Applications_1=Applications[_n-1]
		label var Applications_1 "Applications t-1"
	
reg refgrant l.refgrant l.hp  l.unemp tt, ro
outreg2 using MEPA_TabA7.doc, append ctitle(Quarterly data - rev.) ///
title(Table A7: ODZ approvals, reversals and house prices ) ///
addtext(Time Trend, Y, Estimation, OLS) label

poisson Applications l.Applications l.hp l.ratio l.unemp tt, ro
outreg2 using MEPA_TabA3.doc, append ctitle(Quarterly data) ///
title(Table A3: ODZ applications and house prices)  ///
addtext(Time Trend, Y, Estimation, Poisson) label

* TABLE A5
import excel "/Users/Paul/Dropbox/MEPA/MEPA_Data.xls", sheet("A5") firstrow clear
label variable Advertisement "Advert."
label variable Amendeddevelopmentpermission "Ammended."
label variable Approvalofdetailsreservedby "Reserve Condition."
label variable Fulldevelopmentpermission "Full Permission"
label variable Householderdevelopmentpermissi "Householder."
label variable Internalalterations "Internatl Alt."
label variable Outlinedevelopmentpermission "Outline."
label variable Pre1993Application "Pre-1993"
label variable QuarryingMineralsextraction "Quarrying, Mining."
label variable Renewalofdevelopmentpermissio "Renewal"
label variable SchdpropLBConservatnarea "Scheduled."
label variable Telecommunicationsantennae "Telecomms."
		
label variable notype "Unaffected types"
label variable protype "Affected types"
gen tt=_n
destring(Advertisement Amendeddevelopmentpermission Approvalofdetailsreservedby ///
 Fulldevelopmentpermission Householderdevelopmentpermissi Internalalterations ///
 Outlinedevelopmentpermission Pre1993Application QuarryingMineralsextraction ///
 Renewalofdevelopmentpermissio SchdpropLBConservatnarea ///
 Telecommunicationsantennae), replace

reg Advertisement hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, replace ctitle(Advert.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg Amendeddevelopmentpermission hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Ammended.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg Approvalofdetailsreservedby hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Reserve Condition.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg Fulldevelopmentpermission hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Full Permission) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg Householderdevelopmentpermissi hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Householder.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg Internalalterations hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Internatl Alt.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg Outlinedevelopmentpermission hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Outline.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg Renewalofdevelopmentpermissio hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Renewal) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
 keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg SchdpropLBConservatnarea hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Scheduled.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
 keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg Telecommunicationsantennae hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Telecomms.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

reg protype hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Affected Types.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label
		
reg notype hp_1 pd_1 ratio_1 u_1 tt, ro
outreg2 using MEPA_TabA5.doc, append ctitle(Unaffected Types.) ///
title(Table A5: Reversal ratio and house prices - OLS estimations - OLS estimations) ///
keep(hp_1 pd_1 ratio_1 u_1) addtext(Time Trend, Y)  label

* TABLE A4
import excel "/Users/Paul/Dropbox/MEPA/MEPA_Data.xls", sheet("A4") firstrow clear
label var houseprice "House Price Index"
label var applications "Applications"
label var sharpe "Sharpe"
label var hp_1 "House Price Index t-1"
xtset id year

**Myopic**
xtpoisson applications hp_1  , fe ro
outreg2 using MEPA_TabA4.doc, replace ctitle(Myopic) ///
title(Table A4: District-level ODZ application and house prices - Poisson estimations) ///
keep(hp_1 ) addtext(District FE, Y)  label

**Adaptive**
 xtpoisson applications sharpe  , fe ro
outreg2 using MEPA_TabA4.doc, append ctitle(Adaptive) ///
title(Table A4: District-level ODZ application and house prices - Poisson estimations) ///
keep(sharpe ) addtext(District FE, Y)  label

 **Rational**
 xtpoisson applications houseprice  , fe ro
outreg2 using MEPA_TabA4.doc, append ctitle(Rational) ///
title(Table A4: District-level ODZ application and house prices - Poisson estimations) ///
 keep(houseprice ) addtext(District FE, Y)  label
 
 * TABLE A8
 import excel "/Users/Paul/Dropbox/MEPA/MEPA_Data.xls", sheet("A8") firstrow clear
g hp_1=houseprice[_n-1]
destring(sharpe), replace
label var houseprice "House Price Index"
label var sharpe "Sharpe"
label var hp_1 "House Price Index t-1"
 
 xtset id year

**Myopic**
xtreg reversal hp_1  , fe ro
outreg2 using MEPA_TabA8.doc, replace ctitle(Myopic) ///
title(Table A8: District-level ODZ reversal and house prices - OLS estimations) ///
keep(hp_1 ) addtext(District FE, Y)  label

**Adaptive**
 xtreg reversal sharpe  , fe ro
outreg2 using MEPA_TabA8.doc, append ctitle(Adaptive) ///
title(Table A8: District-level ODZ reversal and house prices - OLS estimations) ///
 keep(sharpe ) addtext(District FE, Y)  label

 **Rational**
 xtreg reversal houseprice  , fe ro
outreg2 using MEPA_TabA8.doc, append ctitle(Rational) ///
title(Table A8: District-level ODZ reversal and house prices - OLS estimations) ///
keep(houseprice ) addtext(District FE, Y)  label
  
  

